﻿CREATE TABLE [dbo].[ElectricityRealtime]
(
[cc_id] [int] NOT NULL IDENTITY(1, 1),
[cc_dateTime] [datetime] NOT NULL,
[cc_watts] [int] NOT NULL,
[cc_joules] [bigint] NULL,
[cc_meterId] [int] NULL,
[cc_minutes] AS (datediff(minute,'1/1/1753',[cc_dateTime]))
) ON [PRIMARY]


